<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->

<html lang="zh-cn" xml:lang="zh-cn">
 <head>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="DC.Type" content="topic">
  <meta name="DC.Title" content="恢复SQL Server实例中的单个或多个数据库">
  <meta name="product" content="">
  <meta name="DC.Relation" scheme="URI" content="sql-0049.html">
  <meta name="prodname" content="">
  <meta name="version" content="">
  <meta name="brand" content="30-OceanProtect 备份一体机 1.5.0-1.6.0 帮助中心">
  <meta name="DC.Publisher" content="20240320">
  <meta name="prodname" content="csbs">
  <meta name="documenttype" content="usermanual">
  <meta name="DC.Format" content="XHTML">
  <meta name="DC.Identifier" content="sql-0152">
  <meta name="DC.Language" content="zh-cn">
  <link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
  <title>恢复SQL Server实例中的单个或多个数据库</title>
 </head>
 <body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px">
  <a name="sql-0152"></a><a name="sql-0152"></a>
  <h1 class="topictitle1">恢复SQL Server实例中的单个或多个数据库</h1>
  <div>
   <p>当需要对已备份的SQL Server实例中的单个或多个数据库恢复时，可以参考本节使用副本恢复数据库至原机或异机。</p>
   <div class="section">
    <h4 class="sectiontitle">前提条件</h4>
    <ul>
     <li>在进行异机恢复时，请确保目标主机上存在数据库实例。</li>
     <li>恢复前请确保恢复目标位置的数据目录剩余空间大于恢复副本缩减前大小，否则恢复将失败。</li>
    </ul>
   </div>
   <div class="section">
    <h4 class="sectiontitle">操作步骤</h4>
    <ol>
     <li><span>选择<span class="uicontrol" id="sql-0152__zh-cn_topic_0000001839142377_uicontrol17392202272717">“<span id="sql-0152__zh-cn_topic_0000001839142377_text1939210224272">数据利用</span> &gt; <span id="sql-0152__zh-cn_topic_0000001839142377_text439314220278">副本数据</span> &gt; <span id="sql-0152__zh-cn_topic_0000001839142377_text14652358184918">数据库</span> &gt; <span id="sql-0152__zh-cn_topic_0000001839142377_text6385151219337">SQL Server</span>”</span>。</span></li>
     <li><span>在<span class="uicontrol">“副本”</span>页签，根据副本的信息找到需要恢复的副本。</span><p></p>
      <div class="note">
       <img src="public_sys-resources/note_3.0-zh-cn.png"><span class="notetitle"> </span>
       <div class="notebody">
        <p>数据库级恢复支持恢复实例的备份副本或复制副本。</p>
       </div>
      </div> <p></p></li>
     <li><span>单击副本所在行的<span class="uicontrol">“更多 &gt; 数据库级恢复”</span>。</span></li>
     <li><span>在<span class="uicontrol">“数据库级恢复”</span>页签左侧框勾选需要恢复的数据库对象，在右侧框选择需要恢复到的目标位置。</span></li>
     <li><span>设置数据库级恢复的相关参数，相关参数说明如<a href="#sql-0152__sql-0052_table93951625101715">表1</a>所示</span><p></p>
      <div class="tablenoborder">
       <a name="sql-0152__sql-0052_table93951625101715"></a><a name="sql-0052_table93951625101715"></a>
       <table cellpadding="4" cellspacing="0" summary="" id="sql-0152__sql-0052_table93951625101715" frame="border" border="1" rules="all">
        <caption>
         <b>表1 </b>数据库级恢复参数说明
        </caption>
        <colgroup>
         <col style="width:32.53%">
         <col style="width:67.47%">
        </colgroup>
        <thead align="left">
         <tr>
          <th align="left" class="cellrowborder" valign="top" width="32.53%" id="mcps1.3.3.2.5.2.1.2.3.1.1"><p>参数</p></th>
          <th align="left" class="cellrowborder" valign="top" width="67.47%" id="mcps1.3.3.2.5.2.1.2.3.1.2"><p>说明</p></th>
         </tr>
        </thead>
        <tbody>
         <tr>
          <td class="cellrowborder" valign="top" width="32.53%" headers="mcps1.3.3.2.5.2.1.2.3.1.1 "><p><span id="sql-0152__sql-0052_text15471356412">恢复至</span></p></td>
          <td class="cellrowborder" valign="top" width="67.47%" headers="mcps1.3.3.2.5.2.1.2.3.1.2 "><p>选择恢复至<span class="uicontrol" id="sql-0152__sql-0052_uicontrol84961241181211">“<span id="sql-0152__sql-0052_text19159183316300">原位置</span>”</span>或<span class="uicontrol" id="sql-0152__sql-0052_uicontrol12496341161217">“<span id="sql-0152__sql-0052_text17983138143120">新位置</span>”</span>。</p></td>
         </tr>
         <tr>
          <td class="cellrowborder" valign="top" width="32.53%" headers="mcps1.3.3.2.5.2.1.2.3.1.1 "><p><span id="sql-0152__sql-0052_text105489481943">位置</span></p></td>
          <td class="cellrowborder" valign="top" width="67.47%" headers="mcps1.3.3.2.5.2.1.2.3.1.2 "><p>当选择恢复至<span class="uicontrol" id="sql-0152__sql-0052_uicontrol5674181313310">“<span id="sql-0152__sql-0052_text48352563919">原位置</span>”</span>时，默认显示原位置。</p></td>
         </tr>
         <tr>
          <td class="cellrowborder" valign="top" width="32.53%" headers="mcps1.3.3.2.5.2.1.2.3.1.1 "><p>标签</p>
           <div class="note">
            <span class="notetitle"> 说明： </span>
            <div class="notebody">
             <p>仅1.6.0及后续版本存在此参数。</p>
            </div>
           </div></td>
          <td class="cellrowborder" valign="top" width="67.47%" headers="mcps1.3.3.2.5.2.1.2.3.1.2 "><p>选择标签名，根据标签名筛选目标主机/集群。</p></td>
         </tr>
         <tr>
          <td class="cellrowborder" valign="top" width="32.53%" headers="mcps1.3.3.2.5.2.1.2.3.1.1 "><p><span id="sql-0152__sql-0052_text329817453610">目标主机/集群</span></p></td>
          <td class="cellrowborder" valign="top" width="67.47%" headers="mcps1.3.3.2.5.2.1.2.3.1.2 "><p>当选择恢复至<span class="uicontrol" id="sql-0152__sql-0052_uicontrol63818461965">“<span id="sql-0152__sql-0052_text625115598103">新位置</span>”</span>时，选择目标主机上的实例。</p>
           <div class="note">
            <span class="notetitle"> 说明： </span>
            <div class="notebody">
             <p>恢复前确保已退出Microsoft SQL Server Management Studio，恢复过程中，系统将关闭目标数据库。</p>
            </div>
           </div></td>
         </tr>
        </tbody>
       </table>
      </div> <p></p></li>
     <li><span>单击<span class="uicontrol">“确定”</span>。</span></li>
    </ol>
   </div>
  </div>
  <div>
   <div class="familylinks">
    <div class="parentlink">
     <strong>父主题：</strong> <a href="sql-0049.html">恢复</a>
    </div>
   </div>
  </div>
 </body>
</html>